Setting Other Field Properties

For bigint, decimal, int, numeric, smallint, tinyint data types:

Identity
Indicate that the new column is an identity column.

For uniqueidentifier data types:

Row GUID Column
Indicate that the new column is a row GUID column. Only one uniqueidentifier column per table can be designated as the ROWGUIDCOL column.

Note: SQL Azure does not support.

For char, nchar, ntext, nvarchar, text, varchar data types:

Collate
Specify the collation for the column.

For xml data types:

Column Set
Combine all of the sparse columns of a table into a structured output.

For varbinary(max) data types:

Filestream
Specify FILESTREAM storage for the varbinary(max) BLOB data.

Note: SQL Azure does not support.

For (USER-DEFINED) data types:

Schema
Set the schema of the user defined type.

User-defined Type
Set the user defined type.

For (COMPUTED) data types:

Expression
Set an expression that defines the value of a computed column.

Persisted
Specify that the SQL Server Database Engine will physically store the computed values in the table, and update the values when any other columns on which the computed column depends are updated.

For most data types:

Default Value
Set the default value for the field.

Sparse
Indicate that the column is a sparse column.

Note: SQL Azure does not support.

For all data types:

Comment
Set any optional text describing the current field.

Note: SQL Azure does not support.